﻿CREATE PROCEDURE aspnet.Personalization_GetApplicationId (
    @ApplicationName NVARCHAR(256),
    @ApplicationId UNIQUEIDENTIFIER OUT)
AS
BEGIN
    SELECT @ApplicationId = ApplicationId FROM aspnet.Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
END